import pandas as pd
import matplotlib.pyplot as plt


catering_sale = './catering_sale.xls'
data = pd.read_excel(catering_sale, index_col = '日期')
print(data.describe())
plt.rcParams['font.sans-serif'] = ['SimHei']
plt.rcParams['axes.unicode_minus'] = False
plt.figure()

p = data.boxplot(return_type='dict')
x = p['fliers'][0].get_xdata()
y = p['fliers'][0].get_ydata()
y.sort()
plt.show()
